Tabela ContractService

Definicja tabeli ContractService

Name

ContractService

Code

ContractService

Comment

Tabela swiadczen


Lista kolumn tabeli ContractService

Name

Code

ContractServID

ContractServID

HospitalizationModeID

HospitalizationModeID

ContractServiceRestrictionID

ContractServiceRestrictionID

ContractServiceTypeID

ContractServiceTypeID

Con_ContractServID

Con_ContractServID

ContractorCode

ContractorCode

ShortName

ShortName

FullName

FullName

PositionInContract

PositionInContract

MZContractCode

MZContractCode

Description

Description

Comments

Comments

Active

Active

CommentsAboutSum

CommentsAboutSum

Code

Code

PackageID

PackageID

UnitID

UnitID

DrugAdministerDose

DrugAdministerDose

IsSuspension

IsSuspension

OutpatientMode

OutpatientMode


Kolumna ContractServID tabeli ContractService

Definicja kolumny ContractServID tabeli ContractService

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospitalizationModeID tabeli ContractService

Definicja kolumny HospitalizationModeID tabeli ContractService

Name

HospitalizationModeID

Code

HospitalizationModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceRestrictionID tabeli ContractService

Definicja kolumny ContractServiceRestrictionID tabeli ContractService

Name

ContractServiceRestrictionID

Code

ContractServiceRestrictionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceTypeID tabeli ContractService

Definicja kolumny ContractServiceTypeID tabeli ContractService

Name

ContractServiceTypeID

Code

ContractServiceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractServID tabeli ContractService

Definicja kolumny Con_ContractServID tabeli ContractService

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractorCode tabeli ContractService

Definicja kolumny ContractorCode tabeli ContractService

Name

ContractorCode

Code

ContractorCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna ShortName tabeli ContractService

Definicja kolumny ShortName tabeli ContractService

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli ContractService

Definicja kolumny FullName tabeli ContractService

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna PositionInContract tabeli ContractService

Definicja kolumny PositionInContract tabeli ContractService

Name

PositionInContract

Code

PositionInContract

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna MZContractCode tabeli ContractService

Definicja kolumny MZContractCode tabeli ContractService

Name

MZContractCode

Code

MZContractCode

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna Description tabeli ContractService

Definicja kolumny Description tabeli ContractService

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Comments tabeli ContractService

Definicja kolumny Comments tabeli ContractService

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli ContractService

Definicja kolumny Active tabeli ContractService

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna CommentsAboutSum tabeli ContractService

Definicja kolumny CommentsAboutSum tabeli ContractService

Name

CommentsAboutSum

Code

CommentsAboutSum

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Code tabeli ContractService

Definicja kolumny Code tabeli ContractService

Name

Code

Code

Code

Data Type

VARCHAR2(15)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna PackageID tabeli ContractService

Definicja kolumny PackageID tabeli ContractService

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitID tabeli ContractService

Definicja kolumny UnitID tabeli ContractService

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Jednostka podania leku


Kolumna DrugAdministerDose tabeli ContractService

Definicja kolumny DrugAdministerDose tabeli ContractService

Name

DrugAdministerDose

Code

DrugAdministerDose

Data Type

NUMBER(19,10)

Mandatory

No

Comment

Dawka leku


Kolumna IsSuspension tabeli ContractService

Definicja kolumny IsSuspension tabeli ContractService

Name

IsSuspension

Code

IsSuspension

Data Type

NUMBER(5)

Mandatory

No

Comment

Kolumna sluzy do oznaczenia czy dane swiadczenie reprezentuje przepustke w
rozumieniu NFZ-owym, ustawiana bedzie przez STER podczas zaczytywania definicji
kontraktów


Kolumna OutpatientMode tabeli ContractService

Definicja kolumny OutpatientMode tabeli ContractService

Name

OutpatientMode

Code

OutpatientMode

Data Type

NUMBER(5)

Mandatory

No

Comment

Informacja czy dany pobyt ma byc rozliczony w trybie ambulatoryjnym


Lista kluczy tabeli ContractService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractService

Definicja klucza Identifier_1 tabeli ContractService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment